SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS OFF
GO

/*
----------------------------------------------------------------------------------------------------

-- Created By:  ()
-- Purpose: Updates a record in the UserAccount table
----------------------------------------------------------------------------------------------------
*/


CREATE PROCEDURE dbo.UserAccount_Update
(

	@Id int   ,

	@Username varchar (50)  ,

	@Title nvarchar (20)  ,

	@FirstName nvarchar (50)  ,

	@LastName nvarchar (50)  ,

	@Password nvarchar (50)  ,

	@PasswordSalt nvarchar (50)  ,

	@LastLogin datetime   ,

	@UserType int   ,

	@CreatedDate datetime   ,

	@UpdatedDate datetime   ,

	@CreatedUser varchar (50)  ,

	@UpdatedUser varchar (50)  ,

	@IsActivity bit   
)
AS


				
				
				-- Modify the updatable columns
				UPDATE
					[dbo].[UserAccount]
				SET
					[Username] = @Username
					,[Title] = @Title
					,[FirstName] = @FirstName
					,[LastName] = @LastName
					,[Password] = @Password
					,[PasswordSalt] = @PasswordSalt
					,[LastLogin] = @LastLogin
					,[UserType] = @UserType
					,[CreatedDate] = @CreatedDate
					,[UpdatedDate] = @UpdatedDate
					,[CreatedUser] = @CreatedUser
					,[UpdatedUser] = @UpdatedUser
					,[IsActivity] = @IsActivity
				WHERE
[Id] = @Id 
				
			

GO
